home *** CD-ROM | disk | FTP | other *** search
/ Developer Source 17 / Developer Source Volume 17 (I-MODE Publications, Inc.)(2000).iso / dbmsa / nov96 / kimbf101.gif < prev    next >
Graphics Interchange Format  |  1998-02-10  |  34.2 KB  |  357x265  |  4-bit (16 colors)
   ocr: ransactioniFact a - . Product Product key Store dimension mension: sorear Ke) Customer key Customer. Sales ticket Salesticket_key dimension dimension Hme key nme Quantity.sold dimension Dollars sold Figure 1. A typical star join schema for a set of retail sales trans- actions. Each fact table record is a line item on a particular customer ticket. In this article, I show how to add a sixth " causal" dimension that explains why the sale took place.